How to: Use the AVERAGE function.
Solution:
Enter =AVERAGE(<cell range>), where <cell range> is a range of cells, and press ENTER.
NOTE: The AVERAGE command calculates arithmetic mean. It totals all values in a specified range, counts how many values there are, and then divides the total by the number of values.
1) Select the cell where the average value should appear. (The cell is highlighted.)
2) Type an equal sign and the AVERAGE command:
=AVERAGE()
3) Do one of the following to specify the cell range containing the values that need to be calculated:
a) Type the range reference within the parentheses of the AVERAGE command.
EXAMPLE: =AVERAGE(D5:D10)
NOTE: No spaces should exist in the formula. For multiple ranges, separate each range with a comma.
b) Select the desired range with the mouse.
NOTE: Be sure that the range is included in parentheses. For multiple ranges, separate each range with a comma.
4) Press ENTER. (Excel displays the average value in the selected cell.)
